SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_UpdateRecruitPosition]
	
	(
	@param_id INT,
	@param_participants_apply INT,
	@param_position NVARCHAR(50),
	@param_target NVARCHAR(50),
	@param_work_area NVARCHAR(50),
	@param_work_city NVARCHAR(50),
	@param_quantity INT,
	@param_professional NVARCHAR(50),
	@param_degree NVARCHAR(50),
	@param_description NVARCHAR(MAX),
	@param_remark NVARCHAR(MAX),
	@param_update_time SMALLDATETIME,
	@param_user_update NVARCHAR(50),
	@param_current_stage INT,
	@param_state bit
	)
	
AS
	/* SET NOCOUNT ON */
	UPDATE dbo.JOL_Recruitment_Position
	SET 
	
	position=@param_position,
	target=@param_target,
	work_area=@param_work_area,
	work_city=@param_work_city,
	quantity=@param_quantity,
	professional=@param_professional,
	degree=@param_degree,
	description=@param_description,
	remark=@param_remark,
	update_time=@param_update_time,
	user_update=@param_user_update,
	current_stage=@param_current_stage,
	state=@param_state
	WHERE
	id= @param_id     
	
	RETURN

GO
